import re

def clean_sql_script(file_path):
    # Open the file for reading
    with open(file_path, 'r', encoding='utf-8') as file:
        content = file.read()

    # Remove comments (both single-line and multi-line)
    content = re.sub(r'--.*?\n|/\*.*?\*/', '', content, flags=re.DOTALL)

    # Remove DROP TABLE statements
    content = re.sub(r'DROP\s+TABLE\s+.+?;', '', content, flags=re.IGNORECASE)

    # Write the cleaned content back to the file
    with open(file_path, 'w') as file:
        file.write(content)

# Example usage:
clean_sql_script('C:/Users/User/Desktop/database/12.sql')